﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Maticsoft.DBUtility;
using System.Data;

namespace BDCS.DAL
{
    public class GetDesignDcriterions
    {
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select a.DTName,b.DSTName,b.DSTDescribe,c.DCID,c.DcriterionContent,c.DcriterionRules");
            strSql.Append(" From T_BuildDesignDcriterionTypes as a inner join T_BuildDesignDcriterionSubTypes as b on a.DTID=b.DTID inner join T_BuildDesignDcriterionContents as c on b.DSTID=c.DSTID ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }
    }
}
